INSERT INTO DibaService.dbo.DibalItemScale (ItemID, ScaleGroup, "FUNCTION")
SELECT Group1, '1',PLU-1
FROM OnlineSales.dbo."Group-PLU" WHERE Group1 IS NOT NULL;


INSERT INTO DibaService.dbo.DibalItemScale (ItemID, ScaleGroup, "FUNCTION")
SELECT GROUP2, '2',PLU-1
FROM OnlineSales.dbo."Group-PLU" WHERE GROUP2 IS NOT NULL;


INSERT INTO DibaService.dbo.DibalItemScale (ItemID, ScaleGroup, "FUNCTION")
SELECT GROUP3, '3',PLU-1
FROM OnlineSales.dbo."Group-PLU" WHERE GROUP3 IS NOT NULL;


INSERT INTO DibaService.dbo.DibalItemScale (ItemID, ScaleGroup, "FUNCTION")
SELECT GROUP4, '4',PLU-1
FROM OnlineSales.dbo."Group-PLU" WHERE GROUP4 IS NOT NULL;

INSERT INTO DibaService.dbo.DibalItemScale (ItemID, ScaleGroup, "FUNCTION")
SELECT GROUP5, '5',PLU-1
FROM OnlineSales.dbo."Group-PLU" WHERE GROUP5 IS NOT NULL;



UPDATE DibaService.dbo.DibalItemScale
SET DibaService.dbo.DibalItemScale.ItemID = DibaService.dbo.DibalItem.ID
FROM DibaService.dbo.DibalItem
INNER JOIN DibaService.dbo.DibalItemScale ON  DibaService.dbo.DibalItem.PluDesc = DibaService.dbo.DibalItemScale.ItemID 